[Microsoft] [ODBC driver manager] no data source name is found and default driver error information is not specified:
Source: Microsoft ole db Provider for ODBC Drivers
Description: [Microsoft] [ODBC driver manager] no data source name found and
Why can't JSP connect to access through ODBC. mdb, but cannot connect. in the accdb database, my URL is also modified accordingly to Stringurljdbc: odbc: driver {MicrosoftAccessDriver (*. mdb ,*. accdb)}; DBQ + dpath; but why is an error reported ??
In order to make full use of the hardware resources, I think a lot of people are using 64-bit operating system, and you can also find that the 64-bit operating system ODBC driver is not found, so the ODBC of things can not be used.Because 2007
I. overview 1.1JDBC concept JDBC (JavaDatabaseConnectivity) is a user interface for connecting to the database provided by Java to support SQL functions. JDBC includes a set of APIS (Java) language-written interfaces and classes are independent of
So far, there have been two Access file formats, one being mdb files, and the other being Accdb files. They have different Chinese methods for importing them to the Mssql database.1. Import in Mdb format:SELECT * into newtab from openrowset
Recently, we need to use java for a small function. We need to link to the access database. I have found a lot on the Internet, and the methods are similar. I will summarize them for your reference. My office version is 2010, so the suffix of the
This code implements the method of connecting the native database.
Operation Steps:
1, access the Control Panel, open "Administrative tools → data Source (ODBC)", pop-up "ODBC Data Source Administrator", in the User DSN tab, click the selected name
Error message: Microsoft is not registered on the local computer. ace.oledb.12.0 "provider.Workaround:Go to Http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe to download. Then the installation
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.